
alter proc sp_database_backup
as

declare @BackupFile varchar(255), @DATE varchar(25),@Description varchar(255), @Name varchar(30), @MediaName varchar(30) ,@DB varchar(30)


	SELECT @DB = 'test', 
	@Name = @DB,
	@BackupFile = 'D:\database_backup\test\' + @Name + '-' + 
	CONVERT(varchar(10), CURRENT_TIMESTAMP , 105) 
	BACKUP DATABASE chiptrac_brecis TO DISK = @BackupFile 
	WITH NAME = @Name, DESCRIPTION = @Description , 
	MEDIADESCRIPTION = @Description,
	STATS =10

